OPTIMIZATION OF BIPARTITE JOINS WITH GRAPH THGORY

An optimization approach for multi-relational joins based on the matching concept in graph theory is introduced. The basic idea lies in constructing a join graph from an expression of N-relation query, and seeking for a maximun matching with minimun total weight. The algorithm for bipartition(X, Y) is proposed in this paper.     

基于数据库的温室环境决策支持系统的设计与实现

用Delphi6．0编写构建了温室环境的决策支持系统。系统中的知识库、模型库和数据库以数据库为基础，采用Database Desktop来设计，有助于系统对知识、模型和相关数据的管理。对系统决策的过程采用基于数据库的方法进行编写，解决了温室环境智能决策过程中推理困难的问题，同时提高了决策的准确程度。     

基于PSS/E参数文件的电力系统可视化图形生成系统

利用PSS/E形成的参数等值数据文件，结合电力系统数字仿真数据结构的特点，提出了一种只需人工输入少量信息(PSS／E节点名)，充分利用已有的PSS/E参数文件，支持等值网络的绘图系统。本系统能自动进行网络拓扑编号；自动从PSS/E参数数据文件中搜索到用于仿真的等值数据、自动进行三相节点编号、计算并保存等值机的数据信息；根据PSS／E数据文件对网络结构进行自检，仿真结果以COMTRADE格式数据输出。本系统减少了用户工作量，充分利用了已有资源，提高了电网分析的智能化和准确性。     

基于SOLID EDGE的EBOM表的生成

论述了BOM的分类和组成方法，介绍了基于Solid edge的EBOM的生成过程，即在Access2002中构建EBOM表，利用Visual Basic编写应用程序，并把在Solid Edge基础上建立的产品模型的物料数据自动生成到EBOM表中。     

高效数据库应用研究

效率是数据库应用开发过程中经常遇到的问题。为此，对数据库应用中影响效率的相关因素(如大事务、数据库连接等)进行分析，并针对实际电子商务数据库0RACE9I与JAVA应用中出现的问题，提出了解决方案。     

Irrigation and food security in the 21st century

Global food projections indicate that food prices in the next threedecades will likely be stable or decline, but progress inreducing malnutrition in developing countries will be slow. Smallshortfalls in crop productivity growth would lead to rising foodprices and worsening malnutrition. Increased food production fromirrigation is essential, and will require expansion of irrigatedarea and water supplies, and improved efficiency of use of existingwater supplies. Neither of these growth factors will prove easy, andboth will require complex institutional and policy reforms. Failureto meet food production needs through efficient expansion andintensification of irrigated agriculture would increase pressure onland resources and hasten the process of environmental degradation.Irrigation and water development strategies have been hampered bya lack of understanding of the links between water scarcity, foodproduction, food security, and environmental sustainability.Research to improve this understanding would have high payoffs.     

论计算机网络安全的形式及基本防范措施

本文探讨了计算机网络安全的形式和如何防范的基本措施.     

农民工社会保障相对独立性初探

以农民工社会保障体系与城镇、农村社会保障体系的关系为研究视角,提出了在现阶段农民工社会保障应相对独立于城镇社会保障体系和农村社会保障体系,这是农民工职业、身份、风险的变化的要求,是农民工社会保障不宜纳入城镇社会保障体系的现实选择。在此基础上,本文还提出建立相对独立的农民工社会保障体系的基本框架:即以工伤保险为先,医疗保险、失业保险、养老保险、最低保障为主,内容逐步扩充。     

A tool for community-based assessment of the implications of development on water security in hillside watersheds

Development and population growth in Latin American countries with steep slope farming are likely to further increase pressures on water and land resources. A methodology was developed for assessing water availability and use under different development pathways at a watershed scale to determine whether water security is a potential problem, and if so, under what conditions it is likely to occur. This methodology makes use of a GIS-based spatial water budget model for simulating stream water availability, water use and stream flow control on a daily basis at a watershed scale. Here, we analysed water availability under three plausible development scenarios for the 3246 ha Cabuyal River watershed in southwest Colombia in the year 2025: Corporate Farming (CF), Ecological Watershed (EW), and Business as Usual (BU). Simulated average river flows at the watershed outlet were, respectively, 874, 796 and 925 l s⁻¹ for the CF, EW and BU scenarios. The contribution of base flow to river flow (base flow index) was on average, 80.8, 85.6 and 77.9%, respectively, for the three scenarios. The watershed had the potential to meet the anticipated increase in water use under each explorative scenario. However, dams were necessary to store irrigation water in the CF scenario, otherwise over 60% of the available water would have been used during the dry season. Such a high figure raises concerns about effects on aquatic and riparian ecology, concentrations of potential contaminants, water reserves for especially low rainfall years, and the watershed resilience to meet temporarily higher water needs during the day. Analyses indicated that current water-use conflicts in the watershed can be resolved if irrigation water supply is separated from drinking water supply. This study helped reduce some of the complexity associated with the interdependencies between land and water resources, the impact of using them, and spatial linkages within the watershed. Results of this study can be used for teaching local stakeholders about basic landscape responses and helping multi-institutional alliances to become proactive and to guide development to the benefit of local communities.